package org.longgang.dao;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.longgang.bean.EducationExperience;
import org.springframework.stereotype.Repository;

/**
 * EducationExperienceDAO继承基类
 */
@Repository
@Mapper
public interface EducationExperienceDAO extends MyBatisBaseDao<EducationExperience, Integer> {
	@Insert({ "insert into education_experience(userid) values (#{userid})" })
	Integer insertEducationExperience(EducationExperience info);

	@Update({"update education_experience set school=#{school},college=#{college},major=#{major},edustarttime=#{edustarttime},eduendtime=#{eduendtime},edustatement=#{edustatement} where userid=#{userid} " })
	Integer updateEducationExperience(EducationExperience info);

	@Select({ "select * from education_experience where userid= #{userid}" })
	EducationExperience selectEducationExperienceById(EducationExperience info);
}